UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tL2M698MqMfS2j1ihHgykb8ATSDelGH3wWfB8nUiJMA=' 
WHERE 
  key_id = '6ed5d0c750783db2f25ebf35d58ca1bf0c7c9139a2bf2a9666a4f8166d1c3c60' 
  AND (
    token = 'tL2M698MqMfS2j1ihHgykb8ATSDelGH3wWfB8nUiJMA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036