UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sKWNs9r3Vb7G2i16/Wcr6x0wgt49IVSUHAZaKlB6/pE=' 
WHERE 
  key_id = 'e464eb856c22c063a45df52e59a6fe7ce957ea1920289470c12f7d96b4276950' 
  AND (
    token = 'sKWNs9r3Vb7G2i16/Wcr6x0wgt49IVSUHAZaKlB6/pE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029