UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xj6gipn3eZvPt6y9Id2tUtMhPch/IDLOEDHNWubwDZc='
WHERE
key_id = '1c928bb99584a7f1d07d58314718c7cede49ac5c6ee31a23feef1a1728f260c3'
AND (
token = 'Xj6gipn3eZvPt6y9Id2tUtMhPch/IDLOEDHNWubwDZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)