UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oD8/Lw8hiDHlR1q1T3jR//yNQHcoGf9wbCbFxvsQ6xY='
WHERE
key_id = 'fd971b5b84eaca0e90ea0d8546cadba0838b5fe463bc59f60cf6441aea72a727'
AND (
token = 'oD8/Lw8hiDHlR1q1T3jR//yNQHcoGf9wbCbFxvsQ6xY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)