UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DbaM8aHKhKc480HZLEZVft1x+lPfgPyBJF8J8EHo5BI=' 
WHERE 
  key_id = '75f89a06e99b0a4494b3fb7ee7b07cc924e90245e75add22ebb4ec0074809ab9' 
  AND (
    token = 'DbaM8aHKhKc480HZLEZVft1x+lPfgPyBJF8J8EHo5BI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029