UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hr9XK1pyshMMwzUzdzhdFbxqhcCKqq5CQFoWgkMDl+E='
WHERE
key_id = '3efca4f9e5bd703b7d168672c08cd83ae58d413c7b4176894d660f592fc86e9d'
AND (
token = 'hr9XK1pyshMMwzUzdzhdFbxqhcCKqq5CQFoWgkMDl+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)