UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFcNIlRC2j1DCn8KtUoa1unI0btIgETmmaKjYkt74rk='
WHERE
key_id = 'd028c9d6c323d04996436cfa433b6f32b0de03e122cd866d7a0621188e296b99'
AND (
token = 'XFcNIlRC2j1DCn8KtUoa1unI0btIgETmmaKjYkt74rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)