UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XTH2AhcY7HKGWaPUXd4vxUy3Fxxhff+ZAxpzhR684dE=' 
WHERE 
  key_id = '6a7ea22a7995a5ddfe7d8c469b39c58e555b5e7e8b23c8c10d026ac9ca16e59b' 
  AND (
    token = 'XTH2AhcY7HKGWaPUXd4vxUy3Fxxhff+ZAxpzhR684dE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044