UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5DR/QZkc2oAGLORUDoFyz0bA2EanqCkyey3tHE+RLQ0=' 
WHERE 
  key_id = '230bba124ac98c846c58d3304034fb21c09701121fcd158f762bb41ead583f3b' 
  AND (
    token = '5DR/QZkc2oAGLORUDoFyz0bA2EanqCkyey3tHE+RLQ0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034