UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'puWc6tHMQcmNdFcBGkFczUUmTJC0BiGCK6K5gUNcoAU=' 
WHERE 
  key_id = '198bbbd00a466e2bf66a4e866170f8ec4fd1ba15a8c901d7e9db7eee688b0af3' 
  AND (
    token = 'puWc6tHMQcmNdFcBGkFczUUmTJC0BiGCK6K5gUNcoAU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038