UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1l9zODGEz/DKlB2YFMPV2W5mMLKwvTmKFKBo51AT1Dw='
WHERE
key_id = 'ffdce10a586fa3def9d4c93bf510cb5178a12e77e043cc12c437b3d4132ded29'
AND (
token = '1l9zODGEz/DKlB2YFMPV2W5mMLKwvTmKFKBo51AT1Dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)