UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QEbvxdc342EnvRftx6gNKcq3oqieOYkwgmrWtJP0eWw=' 
WHERE 
  key_id = '4facf5faa024e48d6b0c924edb7eaed3299bc8ca17a70db71293eb12b2e0b0c1' 
  AND (
    token = 'QEbvxdc342EnvRftx6gNKcq3oqieOYkwgmrWtJP0eWw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027