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