UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBGRxw3gN5h3YNVhgzLMHOyJQEmvQBb+9W1st7gQVkY='
WHERE
key_id = '6223cef299d527f6185c854d1ecfea65e84f61bbc85eaf0fc26f8600010af061'
AND (
token = 'pBGRxw3gN5h3YNVhgzLMHOyJQEmvQBb+9W1st7gQVkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)