UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eEtnZZASi/MHFLwEFmnR3DGUVz5Tyaz2q+Ri7/tn2Jc=' 
WHERE 
  key_id = 'e4aa098cb0c99983e08ed40f394e647edf9b68c5ae9ab67a64fbc6f416bb4ec9' 
  AND (
    token = 'eEtnZZASi/MHFLwEFmnR3DGUVz5Tyaz2q+Ri7/tn2Jc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036