UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TmLvpbo9CzDDV2NXZRqYPv1JI//vK98/3ozLtGoLXKE=' 
WHERE 
  key_id = '1022921f55abb8f9a5a282e3f5162ce65eb8685edd2973f47f6cfc2fc0f6ab30' 
  AND (
    token = 'TmLvpbo9CzDDV2NXZRqYPv1JI//vK98/3ozLtGoLXKE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033