UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xekT0f3Ng0wZOI6vH4p3A2U08ZAVdDBcMCTCNOLoeuk=' 
WHERE 
  key_id = '8ca78cea12f5f79fd40f2e16dc1b22d91356a33c702bcfe1fa00f28a8b1a59f7' 
  AND (
    token = 'xekT0f3Ng0wZOI6vH4p3A2U08ZAVdDBcMCTCNOLoeuk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038