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

Query time 0.00055