UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KFMzr18RmN/UwVPo6yAIK9pNWRfgGNpimI6t4SlKqk4='
WHERE
key_id = '65625c510d7df3de866e060c473989291127d431a47c002a1b23e5801b17ae88'
AND (
token = 'KFMzr18RmN/UwVPo6yAIK9pNWRfgGNpimI6t4SlKqk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)