UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QINCt7QXI8tGkDxYqCf5Zag3Lgg6yXGkq/5IcPUZ694='
WHERE
key_id = '2840460fc38644c3872894578acc097a098324a44d612b824ab11f318ad12590'
AND (
token = 'QINCt7QXI8tGkDxYqCf5Zag3Lgg6yXGkq/5IcPUZ694='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)