UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3YGHu8s0gCtmt8hN6Jl+uJXuMyGRAu7P/yWy9yiuCzU=' 
WHERE 
  key_id = '0e51bb675e42154b58779420f09eff39bdb085c91f1f3e39c594fc63d4205f73' 
  AND (
    token = '3YGHu8s0gCtmt8hN6Jl+uJXuMyGRAu7P/yWy9yiuCzU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021