UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'G4PsB4YCLP2eNjut4QyXu42X2Gv8kWKZRxAwC5g4WvQ=' 
WHERE 
  key_id = '9d83ca858399d68564aef17c1dec5af2d23c670556302d63dfc5b9f3a5fc7f63' 
  AND (
    token = 'G4PsB4YCLP2eNjut4QyXu42X2Gv8kWKZRxAwC5g4WvQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045