UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ACOXISzZyszgRDFEl43HuT/4HKFOBoqN3D/KCfDTt54='
WHERE
key_id = '7bd27ce713d7ff86ae0a3911f47add710d934b7a9afd83e19c1e3b6bfea18247'
AND (
token = 'ACOXISzZyszgRDFEl43HuT/4HKFOBoqN3D/KCfDTt54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)