UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNn63INs4PUBqboa9Q2bthcxWYH/i7SfyhAR9F33rU0='
WHERE
key_id = 'cda803fc5f7ff4faa5897dba86b525ab0be652e8167012865b176a0476d4f092'
AND (
token = 'KNn63INs4PUBqboa9Q2bthcxWYH/i7SfyhAR9F33rU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)