UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+zCx8/eQc2w+uAPby4UPUjXhIIM8SpYd6dE9OX4ZyXg=' 
WHERE 
  key_id = '516031e0584a33c48a4dff5adeec4ace5bc8b7ae9a908f17199b43bd6222dcbc' 
  AND (
    token = '+zCx8/eQc2w+uAPby4UPUjXhIIM8SpYd6dE9OX4ZyXg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034