UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ez95UHa1RTA6SFZjvTC0cGoX5xns3HbBbtieH5nmti8=' 
WHERE 
  key_id = 'a93d1a2ba37ac526d6e8a806a945636249203a5b65b2e2b185c96f59674ef0e3' 
  AND (
    token = 'ez95UHa1RTA6SFZjvTC0cGoX5xns3HbBbtieH5nmti8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036