UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'A41J7vO8wCGuyt7RmZwOzIPN3UfXfAM7jygXMgDcfU4=' 
WHERE 
  key_id = 'fbc577b3f4a7c09a08e5bb8498d20e236fa2f9abaf932b12cbacbcaad391d9df' 
  AND (
    token = 'A41J7vO8wCGuyt7RmZwOzIPN3UfXfAM7jygXMgDcfU4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038