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