UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bS4GQYtD3E7d9mia/LXmPfPWl0CO5Ac4Z8umg6XmsSc=' 
WHERE 
  key_id = 'ce750656828b7c97d73c08f402b62f0b9ed8adcbda0df59f8bc092c698a48719' 
  AND (
    token = 'bS4GQYtD3E7d9mia/LXmPfPWl0CO5Ac4Z8umg6XmsSc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027