UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cz5WyAZ2u16foxdrQt0yB/2isb0htzVPZlaRKmzVBSY='
WHERE
key_id = '1d5670250c9338b61152f1a8b7b365488ad92a290d651ec43348f895bffa710e'
AND (
token = 'Cz5WyAZ2u16foxdrQt0yB/2isb0htzVPZlaRKmzVBSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)