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

Query time 0.00047