UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6codrEnW6fU8rlnMLwejmHYGsEHJaRI8q34V5+x+MKI='
WHERE
key_id = 'ce51b2109df486a12c2b9c05f0c36e598301b08a6a479d9e97b32a45990aad55'
AND (
token = '6codrEnW6fU8rlnMLwejmHYGsEHJaRI8q34V5+x+MKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)