UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nu1cjpLD8mgpJKZfNy8UZH/pTMtphvkNKmPNMvVLiiE='
WHERE
key_id = '42df76b0d1e1abaf3c71952807363147c60598b4fbb30a80553f1abee5c7e3dc'
AND (
token = 'Nu1cjpLD8mgpJKZfNy8UZH/pTMtphvkNKmPNMvVLiiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)