UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8MSscXNC9AkBCx0sptHYI5gi2bM7Kq+rRXoNznFSlo='
WHERE
key_id = 'affefbb81d8fa2d1953ac14f62005850602b7b9eaaeef3e1aeb87e03dd7cc196'
AND (
token = 'q8MSscXNC9AkBCx0sptHYI5gi2bM7Kq+rRXoNznFSlo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)