UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/pMR152R2uttkI/reVbC8+EIUupWaO5c/yzcBGG8Vvg='
WHERE
key_id = 'b2ce4ff3e5420858d640543ffdc838845252ad8b0d24e3f63d6bd711a4efe2a9'
AND (
token = '/pMR152R2uttkI/reVbC8+EIUupWaO5c/yzcBGG8Vvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)