UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtSIMRRitDmollF/EQCkWMIpL2XHRFOeI6dEE9ebtDw='
WHERE
key_id = '9038141a437ca3c67e8161d9fb5be19d21e710e05cb0176f97d60e7a984616be'
AND (
token = 'XtSIMRRitDmollF/EQCkWMIpL2XHRFOeI6dEE9ebtDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)