UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9SZ/LWixT59EaGw19cbK5+Rbu5qNoan7Ba0kYQPyKJw=' 
WHERE 
  key_id = '504fbc49a53b3c4929cb3e04e2df520182e0a51dedfd5e2c4f2985f228fd4097' 
  AND (
    token = '9SZ/LWixT59EaGw19cbK5+Rbu5qNoan7Ba0kYQPyKJw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031