UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zN13dZRFJ5W48kdzRuYjhz/McGK6V3V8jIghRaV8PAc='
WHERE
key_id = 'a2e831a6e5cdd381c9302b0369c79cc979560e4483278fa5635db0b5248f62e7'
AND (
token = 'zN13dZRFJ5W48kdzRuYjhz/McGK6V3V8jIghRaV8PAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)