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