UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nr04uhw9UaEUTRf232WUyRyIh/DuVbc56V2x0D3ljUU=' 
WHERE 
  key_id = '6d23ce6fc80b893e8810eac460b82471142b0119f414320967a4e89d0998abb7' 
  AND (
    token = 'nr04uhw9UaEUTRf232WUyRyIh/DuVbc56V2x0D3ljUU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021