UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vNFe/4102lV2MiuW2Y1xvHd0KZM4i+FrfdCd0rmWehI=' 
WHERE 
  key_id = '621b6bf9e5e795302d4876c923bb45318b9dc15019a2a05fd7589b1c4ea2d62c' 
  AND (
    token = 'vNFe/4102lV2MiuW2Y1xvHd0KZM4i+FrfdCd0rmWehI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029