UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ji/vejCE8w54IfBYjiy35MSCFSmHO539oIDQwVjAbxg='
WHERE
key_id = 'f8aae895ac06f73b5504298c565b1d36ba094ab8ea225b0fe18e4d1f42b77077'
AND (
token = 'ji/vejCE8w54IfBYjiy35MSCFSmHO539oIDQwVjAbxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)