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